Stock Price Report

Dataset statistics

Number of variables	8
Number of observations	2035
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	127.3 KiB
Average record size in memory	64.1 B

Variable types

DateTime	1
TimeSeries	5
Numeric	2

Timeseries statistics

Number of series	5
Time series length	2035
Starting point	0
Ending point	2034
Period	1

Original
Scaled

Alerts

`Open` is highly overall correlated with `High` and 5 other fields	High correlation
`High` is highly overall correlated with `Open` and 5 other fields	High correlation
`Low` is highly overall correlated with `Open` and 5 other fields	High correlation
`Last` is highly overall correlated with `Open` and 5 other fields	High correlation
`Close` is highly overall correlated with `Open` and 5 other fields	High correlation
`Total Trade Quantity` is highly overall correlated with `Open` and 5 other fields	High correlation
`Turnover (Lacs)` is highly overall correlated with `Open` and 5 other fields	High correlation
`Open` is non stationary	Non stationary
`High` is non stationary	Non stationary
`Low` is non stationary	Non stationary
`Last` is non stationary	Non stationary
`Close` is non stationary	Non stationary
`Open` is seasonal	Seasonal
`High` is seasonal	Seasonal
`Low` is seasonal	Seasonal
`Last` is seasonal	Seasonal
`Close` is seasonal	Seasonal
`Date` has unique values	Unique

Reproduction

Analysis started	2023-08-23 10:47:33.351791
Analysis finished	2023-08-23 10:47:40.201735
Duration	6.85 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

Date
Date

UNIQUE

Distinct	2035
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	16.0 KiB

Minimum	2010-07-21 00:00:00
Maximum	2018-09-28 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Open
Numeric time series

HIGH CORRELATION NON STATIONARY SEASONAL

Distinct	1165
Distinct (%)	57.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	149.71373
Minimum	81.1
Maximum	327.7
Zeros	0
Zeros (%)	0.0%
Memory size	16.0 KiB

Quantile statistics

Minimum	81.1
5-th percentile	92.22
Q1	120.025
median	141.5
Q3	157.175
95-th percentile	273.255
Maximum	327.7
Range	246.6
Interquartile range (IQR)	37.15

Descriptive statistics

Standard deviation	48.664509
Coefficient of variation (CV)	0.3250504
Kurtosis	2.240073
Mean	149.71373
Median Absolute Deviation (MAD)	18.5
Skewness	1.5838736
Sum	304667.45
Variance	2368.2345
Monotonicity	Not monotonic
Augmented Dickey-Fuller test p-value	0.3378405913

Histogram with fixed size bins (bins=50)

Gap statistics

number of gaps	0
min	nan
max	nan
mean	nan
std	0

Value	Count	Frequency (%)
148	12	0.6%
120	10	0.5%
157	9	0.4%
142	9	0.4%
155	9	0.4%
116	8	0.4%
143	8	0.4%
151	8	0.4%
110	7	0.3%
132	7	0.3%
Other values (1155)	1948	95.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
81.1	1	< 0.1%
82.1	1	< 0.1%
82.2	1	< 0.1%
82.25	1	< 0.1%
82.4	1	< 0.1%
82.5	1	< 0.1%
82.55	1	< 0.1%
82.6	1	< 0.1%
83.2	1	< 0.1%
83.5	1	< 0.1%

Value	Count	Frequency (%)
327.7	1	< 0.1%
323	1	< 0.1%
317.75	1	< 0.1%
317.6	1	< 0.1%
315.05	2	0.1%
315	1	< 0.1%
314.65	1	< 0.1%
314.3	1	< 0.1%
314	1	< 0.1%
313.85	1	< 0.1%

ACF and PACF

High
Numeric time series

HIGH CORRELATION NON STATIONARY SEASONAL

Distinct	1257
Distinct (%)	61.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	151.99283
Minimum	82.8
Maximum	328.75
Zeros	0
Zeros (%)	0.0%
Memory size	16.0 KiB

Quantile statistics

Minimum	82.8
5-th percentile	93.97
Q1	122.1
median	143.4
Q3	159.4
95-th percentile	276.915
Maximum	328.75
Range	245.95
Interquartile range (IQR)	37.3

Descriptive statistics

Standard deviation	49.413109
Coefficient of variation (CV)	0.32510159
Kurtosis	2.2121497
Mean	151.99283
Median Absolute Deviation (MAD)	18.8
Skewness	1.5864145
Sum	309305.4
Variance	2441.6554
Monotonicity	Not monotonic
Augmented Dickey-Fuller test p-value	0.3095187068

Histogram with fixed size bins (bins=50)

Gap statistics

number of gaps	0
min	nan
max	nan
mean	nan
std	0

Value	Count	Frequency (%)
135	14	0.7%
121	9	0.4%
119.8	8	0.4%
125	8	0.4%
154.5	7	0.3%
143	7	0.3%
148	7	0.3%
156.5	7	0.3%
147.5	6	0.3%
144	6	0.3%
Other values (1247)	1956	96.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
82.8	1	< 0.1%
83	1	< 0.1%
83.4	1	< 0.1%
83.45	1	< 0.1%
83.5	1	< 0.1%
83.7	1	< 0.1%
83.75	1	< 0.1%
83.85	1	< 0.1%
84.3	1	< 0.1%
84.85	1	< 0.1%

Value	Count	Frequency (%)
328.75	1	< 0.1%
328.35	1	< 0.1%
326.9	1	< 0.1%
319.65	1	< 0.1%
319.2	1	< 0.1%
319.1	1	< 0.1%
318	1	< 0.1%
317.8	1	< 0.1%
317	1	< 0.1%
316.7	1	< 0.1%

ACF and PACF

Low
Numeric time series

HIGH CORRELATION NON STATIONARY SEASONAL

Distinct	1263
Distinct (%)	62.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	147.29393
Minimum	80
Maximum	321.65
Zeros	0
Zeros (%)	0.0%
Memory size	16.0 KiB

Quantile statistics

Minimum	80
5-th percentile	90.855
Q1	118.3
median	139.6
Q3	155.15
95-th percentile	267.885
Maximum	321.65
Range	241.65
Interquartile range (IQR)	36.85

Descriptive statistics

Standard deviation	47.931958
Coefficient of variation (CV)	0.32541706
Kurtosis	2.2269384
Mean	147.29393
Median Absolute Deviation (MAD)	18.15
Skewness	1.5735418
Sum	299743.15
Variance	2297.4726
Monotonicity	Not monotonic
Augmented Dickey-Fuller test p-value	0.3978208064

Histogram with fixed size bins (bins=50)

Gap statistics

number of gaps	0
min	nan
max	nan
mean	nan
std	0

Value	Count	Frequency (%)
141	11	0.5%
115	7	0.3%
152.5	7	0.3%
119	7	0.3%
151	7	0.3%
117	6	0.3%
127	6	0.3%
112	6	0.3%
157.7	6	0.3%
116.1	5	0.2%
Other values (1253)	1967	96.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
80	1	< 0.1%
80.3	1	< 0.1%
80.5	1	< 0.1%
81	1	< 0.1%
81.1	1	< 0.1%
81.2	2	0.1%
81.3	1	< 0.1%
81.55	1	< 0.1%
82.1	1	< 0.1%
82.25	1	< 0.1%

Value	Count	Frequency (%)
321.65	1	< 0.1%
315	1	< 0.1%
314	1	< 0.1%
312.55	1	< 0.1%
312.2	1	< 0.1%
311.8	2	0.1%
311.45	1	< 0.1%
310.35	1	< 0.1%
310.15	1	< 0.1%
307.55	2	0.1%

ACF and PACF

Last
Numeric time series

HIGH CORRELATION NON STATIONARY SEASONAL

Distinct	1268
Distinct (%)	62.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	149.47425
Minimum	81
Maximum	325.95
Zeros	0
Zeros (%)	0.0%
Memory size	16.0 KiB

Quantile statistics

Minimum	81
5-th percentile	92
Q1	120.075
median	141.1
Q3	156.925
95-th percentile	273.255
Maximum	325.95
Range	244.95
Interquartile range (IQR)	36.85

Descriptive statistics

Standard deviation	48.73257
Coefficient of variation (CV)	0.32602652
Kurtosis	2.2287442
Mean	149.47425
Median Absolute Deviation (MAD)	18.45
Skewness	1.5848137
Sum	304180.1
Variance	2374.8634
Monotonicity	Not monotonic
Augmented Dickey-Fuller test p-value	0.412917482

Histogram with fixed size bins (bins=50)

Gap statistics

number of gaps	0
min	nan
max	nan
mean	nan
std	0

Value	Count	Frequency (%)
154.2	7	0.3%
115.8	6	0.3%
141.1	6	0.3%
150	6	0.3%
148	6	0.3%
153	6	0.3%
155.5	6	0.3%
149	6	0.3%
120.75	5	0.2%
96	5	0.2%
Other values (1258)	1976	97.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
81	1	< 0.1%
81.1	1	< 0.1%
81.6	1	< 0.1%
82.2	1	< 0.1%
82.4	1	< 0.1%
82.6	1	< 0.1%
82.75	1	< 0.1%
83.05	1	< 0.1%
83.4	1	< 0.1%
83.45	1	< 0.1%

Value	Count	Frequency (%)
325.95	1	< 0.1%
323.7	1	< 0.1%
317.6	1	< 0.1%
317.45	1	< 0.1%
316.05	1	< 0.1%
314.7	1	< 0.1%
314.25	1	< 0.1%
314.05	1	< 0.1%
313.45	1	< 0.1%
313.1	1	< 0.1%

ACF and PACF

Close
Numeric time series

HIGH CORRELATION NON STATIONARY SEASONAL

Distinct	1313
Distinct (%)	64.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	149.45027
Minimum	80.95
Maximum	325.75
Zeros	0
Zeros (%)	0.0%
Memory size	16.0 KiB

Quantile statistics

Minimum	80.95
5-th percentile	92.15
Q1	120.05
median	141.25
Q3	156.9
95-th percentile	273.225
Maximum	325.75
Range	244.8
Interquartile range (IQR)	36.85

Descriptive statistics

Standard deviation	48.71204
Coefficient of variation (CV)	0.32594147
Kurtosis	2.2257142
Mean	149.45027
Median Absolute Deviation (MAD)	18.45
Skewness	1.5832241
Sum	304131.3
Variance	2372.8629
Monotonicity	Not monotonic
Augmented Dickey-Fuller test p-value	0.4115963869

Histogram with fixed size bins (bins=50)

Gap statistics

number of gaps	0
min	nan
max	nan
mean	nan
std	0

Value	Count	Frequency (%)
155.55	6	0.3%
154.85	6	0.3%
141.9	6	0.3%
147.65	5	0.2%
140.8	5	0.2%
153.1	5	0.2%
147.5	5	0.2%
150.2	5	0.2%
132.6	5	0.2%
145.15	5	0.2%
Other values (1303)	1982	97.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
80.95	1	< 0.1%
81.1	1	< 0.1%
81.55	1	< 0.1%
82	1	< 0.1%
82.4	1	< 0.1%
82.5	1	< 0.1%
82.55	1	< 0.1%
82.6	1	< 0.1%
82.7	1	< 0.1%
82.9	1	< 0.1%

Value	Count	Frequency (%)
325.75	1	< 0.1%
323	1	< 0.1%
317.6	1	< 0.1%
316.4	2	0.1%
315.3	1	< 0.1%
314.1	1	< 0.1%
313.55	1	< 0.1%
313.3	1	< 0.1%
312.95	1	< 0.1%
312.9	1	< 0.1%

ACF and PACF

Total Trade Quantity
Real number (ℝ)

HIGH CORRELATION

Distinct	2034
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2335681.4

Minimum	39610
Maximum	29191015
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	16.0 KiB

Quantile statistics

Minimum	39610
5-th percentile	555214.1
Q1	1146444.5
median	1783456
Q3	2813594
95-th percentile	6312189.1
Maximum	29191015
Range	29151405
Interquartile range (IQR)	1667149.5

Descriptive statistics

Standard deviation	2091778.1
Coefficient of variation (CV)	0.89557511
Kurtosis	24.055902
Mean	2335681.4
Median Absolute Deviation (MAD)	739863
Skewness	3.644369
Sum	4.7531117 × 10⁹
Variance	4.3755357 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
839802	2	0.1%
3069914	1	< 0.1%
1762110	1	< 0.1%
3195668	1	< 0.1%
2640664	1	< 0.1%
2807473	1	< 0.1%
1442967	1	< 0.1%
3225051	1	< 0.1%
1828953	1	< 0.1%
2963777	1	< 0.1%
Other values (2024)	2024	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
39610	1	< 0.1%
100180	1	< 0.1%
108287	1	< 0.1%
111115	1	< 0.1%
125170	1	< 0.1%
163605	1	< 0.1%
169762	1	< 0.1%
193726	1	< 0.1%
207063	1	< 0.1%
210300	1	< 0.1%

Value	Count	Frequency (%)
29191015	1	< 0.1%
17917625	1	< 0.1%
17805319	1	< 0.1%
17064363	1	< 0.1%
16822847	1	< 0.1%
15847309	1	< 0.1%
15744338	1	< 0.1%
14490021	1	< 0.1%
14484043	1	< 0.1%
13953152	1	< 0.1%

Turnover (Lacs)
Real number (ℝ)

HIGH CORRELATION

Distinct	2030
Distinct (%)	99.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3899.9806

Minimum	37.04
Maximum	55755.08
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	16.0 KiB

Quantile statistics

Minimum	37.04
5-th percentile	595.585
Q1	1427.46
median	2512.03
Q3	4539.015
95-th percentile	12101.592
Maximum	55755.08
Range	55718.04
Interquartile range (IQR)	3111.555

Descriptive statistics

Standard deviation	4570.7679
Coefficient of variation (CV)	1.1719976
Kurtosis	26.067865
Mean	3899.9806
Median Absolute Deviation (MAD)	1332.16
Skewness	4.0582341
Sum	7936460.4
Variance	20891919
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2140.22	2	0.1%
2195.84	2	0.1%
637.58	2	0.1%
1047.42	2	0.1%
1646.87	2	0.1%
4082.77	1	< 0.1%
2015.28	1	< 0.1%
2261.37	1	< 0.1%
2400.63	1	< 0.1%
3732.17	1	< 0.1%
Other values (2020)	2020	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
37.04	1	< 0.1%
128.04	1	< 0.1%
129.09	1	< 0.1%
147.9	1	< 0.1%
163.11	1	< 0.1%
179.78	1	< 0.1%
186.62	1	< 0.1%
200.97	1	< 0.1%
206.87	1	< 0.1%
216.49	1	< 0.1%

Value	Count	Frequency (%)
55755.08	1	< 0.1%
46643.39	1	< 0.1%
44321.86	1	< 0.1%
43913.37	1	< 0.1%
37901.49	1	< 0.1%
36047.39	1	< 0.1%
33327.37	1	< 0.1%
32325.56	1	< 0.1%
32227.87	1	< 0.1%
31569.51	1	< 0.1%

Auto

Heatmap
Table

	Open	High	Low	Last	Close	Total Trade Quantity	Turnover (Lacs)
Open	1.000	0.998	0.997	0.995	0.995	0.544	0.728
High	0.998	1.000	0.997	0.998	0.998	0.565	0.746
Low	0.997	0.997	1.000	0.998	0.998	0.534	0.720
Last	0.995	0.998	0.998	1.000	1.000	0.554	0.737
Close	0.995	0.998	0.998	1.000	1.000	0.554	0.737
Total Trade Quantity	0.544	0.565	0.534	0.554	0.554	1.000	0.962
Turnover (Lacs)	0.728	0.746	0.720	0.737	0.737	0.962	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Date	Open	High	Low	Last	Close	Total Trade Quantity	Turnover (Lacs)
0	2018-09-28	234.05	235.95	230.20	233.50	233.75	3069914	7162.35
1	2018-09-27	234.55	236.80	231.10	233.80	233.25	5082859	11859.95
2	2018-09-26	240.00	240.00	232.50	235.00	234.25	2240909	5248.60
3	2018-09-25	233.30	236.75	232.00	236.25	236.10	2349368	5503.90
4	2018-09-24	233.55	239.20	230.75	234.00	233.30	3423509	7999.55
5	2018-09-21	235.00	237.00	227.95	233.75	234.60	5395319	12589.59
6	2018-09-19	235.95	237.20	233.45	234.60	234.90	1362058	3202.78
7	2018-09-18	237.90	239.25	233.50	235.50	235.05	2614794	6163.70
8	2018-09-17	233.15	238.00	230.25	236.40	236.60	3170894	7445.41
9	2018-09-14	223.45	236.70	223.30	234.00	233.95	6377909	14784.50

	Date	Open	High	Low	Last	Close	Total Trade Quantity	Turnover (Lacs)
2025	2010-08-03	118.3	119.95	117.90	118.65	118.30	611234	726.78
2026	2010-08-02	117.3	118.50	116.60	118.10	117.30	663593	779.85
2027	2010-07-30	116.5	118.00	114.60	115.85	116.05	2656191	3112.68
2028	2010-07-29	112.5	121.70	112.50	117.50	116.60	2359134	2791.03
2029	2010-07-28	118.0	120.50	117.20	118.15	118.25	835593	994.01
2030	2010-07-27	117.6	119.50	112.00	118.80	118.65	586100	694.98
2031	2010-07-26	120.1	121.00	117.10	117.10	117.60	658440	780.01
2032	2010-07-23	121.8	121.95	120.25	120.35	120.65	281312	340.31
2033	2010-07-22	120.3	122.00	120.25	120.75	120.90	293312	355.17
2034	2010-07-21	122.1	123.00	121.05	121.10	121.55	658666	803.56

Overview

Variables

Interactions

Correlations

Missing values

Sample